Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
-
Re: Custom column in OTBI analysis with case statement is not displaying data in graph
Harpreet, you need to select 'treat as an attribute column' in the column 'Doc Status Interpretation'. FYI - Raghu1 -
Re: Expand Job Application Calculations to Include Inactive Applications
Hi @JT_DC_2023 have you tried using the metric Total Job Applications (On Event) under the folder Facts - Job Application Events? This provides both active and inactive Raghu SELECT "HCM - Talen…1 -
Re: Add measure Number Openings Left to Fill to the FAW HCM Talent Acquisition Job Requisition fact
Hi @Mike Tytler @Gina DiVenti Thanks for the feedback. I plan to have 2 measures for Openings Filled Count(Job Application ID) Where Phase = HR and State Not IN (Rejected, Withdrawn) - same logic as …1 -
Re: Headcount Turnover - How is it calculated?
Hi All, thanks for engaging on this topic. I agree with Sushanta's response above. The average depends on the grain of the query. If year is the lowest grain then the headcount as of first day a…2 -
Re: Displaying last 12 Months of Data based on Current Month Parameter in OAC
an another version of this can be like below "HCM - Workforce Core"."Time"."Date" BETWEEN TIMESTAMPADD(SQL_TSI_MONTH,-11,CURRENT_DATE) AND CURRENT_DATE1
